Those darn checkboxes!! Please help!!
I posted a little over a week ago a problem I was having with option buttons and check boxes. I got a reply to exactly what I asked for, however now I am running into a few other problems. I had asked how to make the checkboxes uncheck and combo boxes go back to 'Choose a color' when the 'Standard Features' option button was clicked and that code worked famously:) . But now I am finding I need something just a little more. I don't want the user to be able to check the checkboxes or combo boxes unless they click on the 'Upgrade Features' option button. In other words, I don't want them to be able to click on anything at first except Upgrades, (Standard Features is already ticked when they open the sheet). I have attached the same form as last time. Also, when I activate Protection (Protect Sheet) after assigning the macro 'Standard' to 'Standard Features', I get a pop-up saying I am trying to change something that is protected and therefore read only. I have the buttons unlocked. And I even tried it with the cell unlocked as well.:confused: Any help or suggestions would be greatly appreciated!!!! Thanks in advance!! +-------------------------------------------------------------------+ |Filename: Paint Upgrades.zip | |Download: http://www.excelforum.com/attachment.php?postid=5101 | +-------------------------------------------------------------------+ -- Sweetpea ------------------------------------------------------------------------ Sweetpea's Profile: http://www.excelforum.com/member.php...o&userid=36419 View this thread: http://www.excelforum.com/showthread...hreadid=564917 |
All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com