LinkBack URL
About LinkBacks
Hi all,
i have a excel template for accounting function. i have to tally the some of cells.
can we set, if Cell A1 = change as "false", then a warning option have to display whenever we give save that workbook?
Regards
Jack
Hi all,
i have a excel template for accounting function. i have to tally the some of cells.
can we set, if Cell A1 = change as "false", then a warning option have to display whenever we give save that workbook?
Regards
Jack
Hi Mate,
Welcome to the forum..
Here you go.. Add the below code as a private sub on your workbook sheet like below - ( To add a private sub - ALT+F11 ---->> Click on sheet names on left hand side of the window i.e. Sheet1 or Sheet2 and paste below code on right hand window)
You would then need to enable macros.. And You should be fine
Please Login or Register to view this content.
Last edited by bonny24tycoon; 08-02-2012 at 06:50 AM. Reason: Updated codes
Thanks,
Bonny Tycoon
Hi Boony,
It working find thanks for your help... ( Am little scared, when i saw you location)
Regards
Jack
Thats great I have you query resolved..
Haha.. No worries mate.. I'm from India too..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks