Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
error accessing a protected worksheet
Hi
I have a worksheet that I want to protect so that only cells that are unlocked can be edited. When I activate protection and try to click on a cell (regardless of this is a locked cell or not) I get the following error "The macro filename_macroname cannot be found". I used to have this macro in the spreadsheet, but it is now removed. When I look in Tools, Macro, Macros there are noe registered macros. I have also tryed to create a new macro with this name. When I put on protection it seams like the whole spreadsheet is being treated as a shortcut button. Regardless of where I click with the mouse the macro command is performed. Does somebody know why this happens? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Sorting Protected Worksheet | Excel Discussion (Misc queries) | |||
In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
Sorting on a protected worksheet | Excel Discussion (Misc queries) | |||
Sorting protected worksheet | Excel Discussion (Misc queries) |