+ Reply to Thread
Results 1 to 5 of 5

VBA set Protect Sheet - Format Columns and Rows

  1. #1
    dellschipper
    Guest

    VBA set Protect Sheet - Format Columns and Rows

    I have VBA code to set a password on multiple worksheets in a workbook. I new need to force a check in the "Format Columns" and "Format Row" checkboxes.

    The current VBA code is:
    Please Login or Register  to view this content.
    What needs to be added?

    Thanks!
    Last edited by dellschipper; 06-11-2009 at 05:58 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VBA set Protect Sheet - Format Columns and Rows

    Open the VBE, and in the Help box, enter Protect Method, and then select ... as it applies to the Worksheet object. It's all explained.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    dellschipper
    Guest

    Re: VBA set Protect Sheet - Format Columns and Rows

    Thanks for the pointer. I updated the VBA code to:

    Code:
    Please Login or Register  to view this content.
    Now I get a "Run-time error '424': Object required". What am I doing wrong?

    Thanks!

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VBA set Protect Sheet - Format Columns and Rows

    They are all arguments to the same method:
    Please Login or Register  to view this content.

  5. #5
    dellschipper
    Guest

    Re: VBA set Protect Sheet - Format Columns and Rows

    Perfect! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1