Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Protected sheets and Macro Runing Problems

  Asked By: Seth    Date: Aug 24    Category: MS Office    Views: 882
  

I have a shared xl file with protected sheets.



I have made a macro to "Unfilter" all the columns that are filtered



When I run the macro without protecting the sheets all is OK. But when I
protect the sheets and I share the file the "Unfilter" macro gives me an
error.



CAN SOME ONE HELP ME TO SOLVE THIS PROBLEM??

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Glenda Frazier     Answered On: Aug 24

The sheet protection won't let this happen. Your code needs to unprotect
the sheet, complete the operation, then protect it again. You can use
the macro  recorder to generate the code to do this.

 
Answer #2    Answered By: Vilmos Fischer     Answered On: Aug 24


As I have try is not possible because the file  is SHARED.

The macro  to "Unfilter" is in the personal file.
I have made  an icon in the formatting bar and I have assigned the "Unfilter"
macro. Like this it works very well with:

> Unprotected sheets  in shared files
> Unprotected sheets in non-shared files

In my opinion the problems  is because the file is a shared.

 
Didn't find what you were looking for? Find more on Protected sheets and Macro Runing Problems Or get search suggestion and latest updates.




Tagged: