Macros and VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-1597945%22%20slang%3D%22en-US%22%3EMacros%20and%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1597945%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%20that%20i%20have%20an%20excel%20sheet%20which%20has%20macros%20in%20it%20and%20some%20basic%20formulas%2C%20now%20when%20i%20protect%20and%20put%20some%20permissions%20for%20end%20users%20like%20filter%2C%20hyperlinks%20to%20be%20enabled%20while%20my%20sheet%20is%20protected.%20What%20happens%20is%20that%20when%20any%20end%20users%20perform%20changes%20to%20the%20sheet%20and%20save%2C%20the%20permissions%20which%20i%20granted%20before%20(i.e.%20hyperlinks%20and%20filter)%20are%20disabled.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20guide%20me%20on%20this.%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%26nbsp%3B%3C%2FP%3E%3CP%3EMajid%20Pervaiz%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1597945%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Dear All, 

 

Please note that i have an excel sheet which has macros in it and some basic formulas, now when i protect and put some permissions for end users like filter, hyperlinks to be enabled while my sheet is protected. What happens is that when any end users perform changes to the sheet and save, the permissions which i granted before (i.e. hyperlinks and filter) are disabled. 

 

Can someone please guide me on this. 

Regards, 

Majid Pervaiz 

0 Replies