My Command Button stops working whenever I protect the attached worksheet, and I am told that I need a Macro to keep it working.
I know nothing about Macros.
What Macro will keep the sheet working, when it is protected?
The Control Button is in Sheet 2.
I am using Excel 2010.
mgs
Last edited by mgs; 03-20-2013 at 09:16 PM.
Hi mgs
Don't see a Button...where is it and what's it meant to do?
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hello - No macro is needed here...
Cell E10 is the problem.. Cell E10 needs to stay "unlocked" when you protect your sheet.
You could "copy" & "past" that cell to another unused area of the sheet. (Cell O1 for example) - Than hide column O - Then protect your sheet.
The Button (green, and called "The odometer displays...") is on the "Print Me" page.
It determines whether the odometer entries (on the "Field Sheet" page) are in miles or kilometres.
The intention, is to minimise/simplify the motorist's data input (on the "Field Sheet" page), and make the necessary conversions.
Bingo, you're on the money!
I will do as you recommend.
Thanks very much!
Bingo, you're on the money!Originally Posted by NANDO-T
I will do as you recommend.
Thanks very much!
Hello again mgs.
I wrote "copy" & "paste" - It should be "CUT" & "past".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks