found this on the internet, i can now insert an activex control text box into a spread sheet
Enable ActiveX controls in Office 2024
Select File, then Options.
Select Trust Center, then the Trust Center Settings button.
Select ActiveX Settings, then make sure Prompt me before enabling all...