Need help regarding marco settings...... Using MS Excel 2007. I created a workbook that contain macros to process data and fill in multiple listboxes. One of the macros list out the mutliple selected items from one of the listbox to a specified range (surface). The Macro setting on the users machine is "Disable all macros with notification". So when they open the file, they see the MS message onbelow the tool bar that reads: "Security Warning Some active content has been disabled." with and Option button. The Option buttin brings the user to the "Security Alert - Macros & ActiveX" message, so the user can select either "Help Protect me from unknown content(recommended)" or "Enable this content".....Even when the user selects the "Enable" option, some macros still do not work.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro Setting with MS Excel 2007
- Thread starter atf32
- Start date
Need help regarding marco settings...... Using MS Excel 2007. I created a workbook that contain macros to process data and fill in multiple listboxes. One of the macros list out the mutliple selected items from one of the listbox to a specified range (surface). The Macro setting on the users machine is "Disable all macros with notification". So when they open the file, they see the MS message onbelow the tool bar that reads: "Security Warning Some active content has been disabled." with and Option button. The Option buttin brings the user to the "Security Alert - Macros & ActiveX" message, so the user can select either "Help Protect me from unknown content(recommended)" or "Enable this content".....Even when the user selects the "Enable" option, some macros still do not work.Excel Facts
What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,084
- Office Version
- 365
- Platform
- Windows
I would recommend either:
- Digitially signing your macros, then have the users accept your signature. Then all workbooks with macros signed by you will open up fully enabled on their computers.
OR
- Setting up Trusted Locations on their computers (entering in the location of the Excel file). Then any file that they open up from one of their Trusted Locations will have their macros fully enabled.
- Digitially signing your macros, then have the users accept your signature. Then all workbooks with macros signed by you will open up fully enabled on their computers.
OR
- Setting up Trusted Locations on their computers (entering in the location of the Excel file). Then any file that they open up from one of their Trusted Locations will have their macros fully enabled.
Upvote
0
