ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   error accessing a protected worksheet (https://www.excelbanter.com/excel-worksheet-functions/73673-error-accessing-protected-worksheet.html)

Erik Jahre

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?


All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com