Davespil
07-18-2016, 09:25 AM
Hello. Using Excel I created a worksheet that allows other users to enter some data and select data from drop down menus and get a solution. I use worksheet 1 as the user interface and have a bunch of data and formulas on the next worksheet. It works well but I came across two problems and I don't know if they can be fixed. Here they are:
#1. I have the worksheet protected and only the cells that data entry is needed unlocked. I also have a macro that runs when the workbook is opened. It hides certain rows. The problem is a protected worksheet and macros that hide or unhide rows don't work together. Is there a way past that? I really want to limit the cells that the user has access to but I also need certain rows hidden unless the used decides to unhide them (using another macro tried to a button).
#2. If the button that I have that hides/unhides certain rows is clicked while the user's cursor is in one of the cells to be hidden then that row is not hidden. The rest are but Excel won't hide that row if it's clicked on. Is there a way to override that?
I know these are some weird questions but I am trying to lock down this user interface. Thank you in advance.
#1. I have the worksheet protected and only the cells that data entry is needed unlocked. I also have a macro that runs when the workbook is opened. It hides certain rows. The problem is a protected worksheet and macros that hide or unhide rows don't work together. Is there a way past that? I really want to limit the cells that the user has access to but I also need certain rows hidden unless the used decides to unhide them (using another macro tried to a button).
#2. If the button that I have that hides/unhides certain rows is clicked while the user's cursor is in one of the cells to be hidden then that row is not hidden. The rest are but Excel won't hide that row if it's clicked on. Is there a way to override that?
I know these are some weird questions but I am trying to lock down this user interface. Thank you in advance.