Hi All - how can I get an alert to pop up when an excel file is opened that says "Please only input information into shaded cells"
Any help would be greatly appreciated!
Thank you
Hi All - how can I get an alert to pop up when an excel file is opened that says "Please only input information into shaded cells"
Any help would be greatly appreciated!
Thank you
Hi, mrr2,
into ThisWorkbook:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thanks Holger - is this right? I added it to my existing recorded macro, and it does not pop up when i open the workbook and enable macros?
Please Login or Register to view this content.
Thanks Holger - is this right? I added it to my existing recorded macro, and it does not pop up when i open the workbook and enable macros?
Please Login or Register to view this content.
Hi, mrr2,
is the code located in ThisWorkbook? In any other module the event will not get fired.
Ciao,
Holger
Hi Holger - I added it on top of the exisisting code in the workbook - is that correct?
Holger I'm good - thanks a lot for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks