Hi All,
I am pulling together a quotation spreadsheet and I was wondering if it was possible to add a macro that will pop up a message saying "No Quote Number" prior to printing if there is no data within cell "L10"?
Many Thanks,
Jon
Hi All,
I am pulling together a quotation spreadsheet and I was wondering if it was possible to add a macro that will pop up a message saying "No Quote Number" prior to printing if there is no data within cell "L10"?
Many Thanks,
Jon
Whether It should happen for every sheet of that workbook or for a particular sheet?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Sixthsense,
It's for one paticular sheet (only one is visable). All the rest will be hidden and locked to users.
Thanks,
Jon
Do right click on sheet tab and select view code and double click THISWORKBOOK in project explorer and paste the below code:-
Please Login or Register to view this content.
Fantastic!!
Thanks, will mark as solved.
Regards,
Jon
Glad it helps you and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks