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!

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

How to avoid or fix message like "the macro may not be available in this workbook or all macros

Status
Not open for further replies.
feipezi

feipezi

IS-IT--Management
Aug 10, 2006
316
US
Hi,

I went to File->Options->Trust Center setting->macro settings and tried to check "enable all macros..." but I was unable to because it's a company PC and I don't have admin right to do so.

Any suggestions?

Thanks in advance.

 
Sort by date Sort by votes
It's typical of IT security to either 1) require all users to select Enable Macros or even 2) to disable ALL the use of embedded macros in applications like Excel or Word.
 
Upvote 0 Downvote
Where is the macro and how do you try to call it?

combo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
488
strongm
strongm
foxup
  • Locked
  • Question
CDO TLS or SSL
Replies
1
Views
204
foxup
foxup
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
187
mintjulep
M
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
289
mikrom
mikrom
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
311
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top