form at startup

[leibale]

can I make a form to apear at startup, even before the user give permission to work with macros

 

[baitmaster]

No. You need macros to display the form

Alternative is to force user to enable macros, or use activeX controls on a worksheet (they wont work with macros disabled though)

 

[leibale]

No. You need macros to display the form

Alternative is to force user to enable macros, or use activeX controls on a worksheet (they wont work with macros disabled though)

thank you,
I want a FORM because I can show it also when the window is not visible
what is your idea about forcing the user to enable macro?

 

[baitmaster]

It's posted via my own question thread http://www.mrexcel.com/forum/showth...rashing-Excel-2010-force-macros-to-be-enabled, but note that I had some trouble with it in Excel 2010. Seems ok in all other versions though, and the original source describes the problem and the solution well

 

[Major Tom]

Check thread...., may be a clue.
Excel 2010 startup does not complete display update.