Hi guys,
Does anyone know of a way to automatically run a macro on open once only? i.e. A user opens an excel worksheet, a macro is run prompting them for some information, they save the file, re-open it however this time it does not prompt for the questions? Please see below for my macro. Any help would be greatly appreciated.
Please Login or Register to view this content.
Last edited by VBA Noob; 10-24-2007 at 03:32 AM.
This will call the your macro "Project"Please Login or Register to view this content.
The code Workbook_Open goes into the workbook module
here it is explained
http://www.contextures.com/xlvba01.html
Last edited by davesexcel; 10-24-2007 at 05:27 AM.
Thanks for the reply Dave however every time I open the file, it will re-run the macro. I only want it to run once the first time the user opens the file and as soon as they save the document, the prompts will not occur. I think there will have to be a counter or something in the macro to say if counter is greater than 1 do not run.
I've written a work around to resolve my issue. Basically just an If statement to say if the cell is Null, prompt with questions. Thanks for your help though Dave. Much appreciated.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks