Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Allow custom update button to work while sheet is protected
I have two sections on my sheet. One being a query and the next section for
users to input data. The query is protected and the later can be edited. However, I would like to allow users to click on an update button which I have programmed to update the queries from database. When the sheet is protected, users failed to click on the button eventhough I have uncheck the lock property. This is the code for the update button: Private Sub cmdButton_RefreshMDBF_Click() Range("MDBF_Query").QueryTable.Refresh BackgroundQuery:=False Range("Plan_MDBF_Query").QueryTable.Refresh BackgroundQuery:=False Range("MDBF_Plan").Calculate End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding columns, custom views, protected sheet | Excel Discussion (Misc queries) | |||
Custom Toolbar Button No Longer Runs Assigned Macro | Excel Discussion (Misc queries) | |||
when I protect my sheet enter tab, & arrow keys dont work... | Excel Discussion (Misc queries) | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions |