Protect Sheets Macro Fails on Excel Sheets
12.3 هزار بار بازدید -
12 سال پیش
-
http://blog.contextures.com/archives/...
To quickly and easily protect all the sheets in an Excel file, you can use a simple macro, like the one shown in my blog post, at the link above.
However, even a simple macro can run into problems, in some situations. In this video, the Unprotect macro works well the first time, but doesn't unprotect the sheets when we try the macro again. When running the macro, an Error 1004 message appeared.
The problem was caused by grouped sheets, which can't be unprotected. A line of code is added to the macro, and the problem is solved.
To quickly and easily protect all the sheets in an Excel file, you can use a simple macro, like the one shown in my blog post, at the link above.
However, even a simple macro can run into problems, in some situations. In this video, the Unprotect macro works well the first time, but doesn't unprotect the sheets when we try the macro again. When running the macro, an Error 1004 message appeared.
The problem was caused by grouped sheets, which can't be unprotected. A line of code is added to the macro, and the problem is solved.
12 سال پیش
در تاریخ 1391/02/06 منتشر شده
است.
12,372
بـار بازدید شده