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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

really no way to not see the box enable/disable macros?

Status
Not open for further replies.
DeSn

DeSn

Programmer
Joined
Nov 20, 2001
Messages
111
Location
BE
I know i can use a certificate of set the security on low, but isn't there another way? Because each of the two previous solutions take actions at the person's (who uses the documents) pc.

Anyone?
 
Sort by date Sort by votes
Put the macro on your PERSONAL.XLS workbook
 
Upvote 0 Downvote
nope - the only way is a bit of a bug - and that's to open the workbook via code from another workbook (XP only) - but then, you still have to enable macros on the 1st workbook.

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Question Question
Ecel Macros not working with V 2505
Replies
4
Views
199
remeng
remeng
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word
Replies
7
Views
2K
strongm
strongm
2009luca
  • Locked
  • Question Question
put value in input box web page
Replies
0
Views
401
2009luca
2009luca
morechocolate
  • Locked
  • Question Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
2K
morechocolate
morechocolate
remeng
  • Locked
  • Question Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
1K
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top