Protect all objects in visible sheets

**tapapad** · 11-13-2008, 04:09 PM

Hello,

Could someone suggest some VBA code to protect all objects in visible sheets?

Are charts included in the objects collection?

thanks
tasos

**Andy Pope** · 11-13-2008, 04:42 PM

Yes I think charts are included as objects.

What version of excel?

Have you tried using the macro recorder whilst applying sheet protection?

**tapapad** · 11-13-2008, 05:03 PM

Hi,

i am using excel 2007.. I wasn't able to use the macro recorder to protect objects.. I think this can only be done via VBA.

**Andy Pope** · 11-13-2008, 05:12 PM

The macro recorder gave me this when protecting the sheet

Please Login or Register  to view this content.

This will lock all the shapes/objects on the activesheet

Please Login or Register  to view this content.

To get at the dialog to format a shape manually select it
Drawing Tools > Format > Size > dialog launch (small arrow bottom right corner of group)

**tapapad** · 11-14-2008, 12:35 PM

thanks Andy

are graphs included within the shapes collection?

I am still a bit confused.

I need two separate procedures:

- One to protect only the charts for all sheets

- One to protect all objects for all sheets

thanks again for all your help

**Andy Pope** · 11-14-2008, 12:44 PM

Yes chartobjects are part of the shapes collection.

To get just chart objects then this for each loop

Please Login or Register  to view this content.

**tapapad** · 11-14-2008, 04:05 PM

ok, this is the reason i am confused..

I have some charts with data tables and I use your procedures and they still are not protected... they can be moved around and changed.

I am using Excel 2007.

thanks
andy

**tapapad** · 11-14-2008, 04:57 PM

my bad... its now working as expected... thanks for your help Andy :-)

Protect all objects in visible sheets

LinkBack

Thread Tools

Rate This Thread

Display

Protect all objects in visible sheets

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions