Hi,
I have made this macro, so you can unprotect and protect the sheet by clicking on a box.
But the issue is, that the workbook is a shared file, so the macro's doesn't work.
any ideas?
Feel free to make alternative solution if the one i have made can be done better
PW:
1234 or 9999
Good morning MetteGaga
You can run macros from a shared workbook. You just can't edit or record them - the code is not accessible.
Could there be something else with your workbook that is stopping it from running. Does it not work on all devices? What happens when you click the button? I'm assuming that macros are always enabled?
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
@Dominic,
You can't alter protection in a shared workbook, so the macro won't work.
Remember what the dormouse said
Feed your head
Hi rorya
Well remembered - super spot.
DominicB
Im running out the door but I'm sure I used this combination years ago to do same thing
apologies if wrong
Please Login or Register to view this content.
This I used before and just tried in Excel 2016 64bit and turns on and off VBA Editor access, maybe helps
Last edited by nigelog; 11-09-2018 at 10:39 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks