Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Macro Not Woking fro Some Users

Status
Not open for further replies.

DylaBrion

Technical User
Dec 18, 2018
45
GB
Hello

Can you please help. I have developed a macro enabled excel workbook with VBA code providing functionality. The code works fine on my laptop / desktop but does not seem to run from the same button for a user on another PC.

When the user clicks the button they receive a warning message saying "Cannot Run Macro xxxxxx The macro may not exist or all macros have been disabled

The user has enabled content / enabled all macros in the Trust Centre

The user was also able to run the macro manually

However, clicking the button generates the warning message

Any advice would be appreciated

Thanks
 
The other computer: when you open the file, right-click the button, and choose "assign macro...", can you see the required macro in available macros list? What can you see in the scope (macro in:) drop-down?

combo
 
Hi Combo

Apologies for the long delay on my replying

This worked so many thanks for your help

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top