Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control ComboBoxes & Worksheet Protection
Hi, I have been creating a user form whereby the user selects a record from a combo box. Once they have made a selection I have a macro that highlights cells on the same worksheet. The worksheet is protected, so I would like, via use of the OnChange Event(or something else) for the worksheet to unprotect, change the highlighted cells, then reprotect leaving the user with no access to the sheet other than to view it. I have tried an array of Macros none seem to work. They work on a sheet where the combobox is missing, i think this could be the problem, but can not find away around it. Any ideas? Many Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control ComboBoxes & Worksheet Protection
If you are using a form, then add this to the top of your command button
click_event code. Sheetname.Unprotect "password" the rest of your code then at the end add: Sheetname.Protect "password" HTH "ChrisF" wrote in message ... Hi, I have been creating a user form whereby the user selects a record from a combo box. Once they have made a selection I have a macro that highlights cells on the same worksheet. The worksheet is protected, so I would like, via use of the OnChange Event(or something else) for the worksheet to unprotect, change the highlighted cells, then reprotect leaving the user with no access to the sheet other than to view it. I have tried an array of Macros none seem to work. They work on a sheet where the combobox is missing, i think this could be the problem, but can not find away around it. Any ideas? Many Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comboboxes | Excel Discussion (Misc queries) | |||
Comboboxes | New Users to Excel | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Need help with ComboBoxes. | New Users to Excel |