Hi!
I have a few Worksheets, each one has their own functions, some have multiple Modules and buttons, etc... but the entire Workbook and all sheets must be locked or "Protected"... if so, some functions don't work.
So is there a VBA code I can add to the Workbook, to temporarily unlock/unprotect everything for a Module or button to do it's job, then put it back in protection mode again?
Thanks!
if you add the following to the ThisWorkbook module your code will be able to do almost anything without issue
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
It works... there is only one function that doesn't while under protection. And that's a ComboBox. As long as the "Cell Link" is locked. It can't work. So, anything to get around this? Perhaps assign a Macro to the ComboBox??? I dunno?
Thanks!
don't lock the linked cell. :-)
Right. But is there any other option besides that?
don't link it. use code to populate the cell in the change event of the combobox (or the assigned macro if it's a Forms control)
btw there is no need to pm me to tell me you've posted-I get notified by email
Okay that sounds good, only if I knew how to do that. Keep in mind though, there are other VB code and worksheets that are feeding off of the information that cell link provides. Thoughts?
Also of note, the "Input Range" remains locked, and the comboBox still works. However, only the "Cell link" is the issue when locked.
the input range isn't being changed so that's not an issue. is there a reason you can't unlock the linked cell?
The main reason why cells are locked is because users who are not so computer savvy may inadvertently delete cells that they shouldn't, thus compromising the programming. So all cells are locked, except the ones for data entry.Originally Posted by JosephP
The user uses the "ComboBox" to make a selection and thus "changes" his choice based on the input range. And his choice generates a different result in the "Cell Link."
but the linked cell is for data entry. if they delete the contents then selecting an item from the combobox will reinstate the value.
That's true. Besides, I guess I'm asking for something that can't be done.
Thanks for your help! Everything else works great!
oh it can be done-I just don't see the need. ;-)
That's true. Besides, I guess I'm asking for something that can't be done.
Thanks for your help! Everything else works great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks