LinkBack URL
About LinkBacks
Hi,
On the Events Calendar sheet I would like to be able to change the year with the spin button when the sheet is protected. How can this be done please? Does the button need to be changed or the code altered?
Thank you very much
Hi,
On the Events Calendar sheet I would like to be able to change the year with the spin button when the sheet is protected. How can this be done please? Does the button need to be changed or the code altered?
Thank you very much
Well....Considering that there is NO "Events Calendar Sheet" and NO Spin Button...It cannot be done...
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Sorry I attached the wrong version. Please see attached.
All you need to do is unlock the cell with the year in it.
I would prefer that the cell can't be altered by the user. Is there another way please?
The monthly button works when protected.
Last edited by crazyforexcel; 01-12-2020 at 11:21 AM.
Either use an activeX spinner, or use two form control buttons formatted to look like a spinner.
If you use an ActiveX spinner you can use
Please Login or Register to view this content.
Thank you very much Fluff13 that is perfect!
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks