Results 1 to 6 of 6

Lock Sheet Tabs Using VBA

Threaded View

Joey5105 Lock Sheet Tabs Using VBA 10-13-2008, 03:57 PM
Richard Buttrey Hi, I think the simplest... 10-13-2008, 06:23 PM
Joey5105 That works great! Thank you.... 10-13-2008, 07:50 PM
Joey5105 Actually, I spoke to soon. ... 10-13-2008, 07:59 PM
Joey5105 On workbook close event, I... 10-13-2008, 08:18 PM
Joey5105 I spoke too soon. I am... 10-15-2008, 08:35 PM
  1. 10-13-2008, 03:57 PM #1
    Joey5105 is offline
    Registered User
    Join Date
    09-14-2008
    Location
    Honolulu Hawaii
    Posts
    45

    Lock Sheet Tabs Using VBA

    Aloha Friends:

    I need to get rid of the option to DELETE a sheet. However, when I password protect the WORKBOOK (which does this fine) none of the Macro buttons will execute, even with Macro security settings set to ENABLE ALL.

    Looks like I will need some VBA code to not allow any of the sheets in the workbook to be deleted.

    I did alot of searching online and on this site, and wasn't able to find anything suitable. Is this possible?
    Last edited by VBA Noob; 10-14-2008 at 02:16 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to Lock cells in protected sheet depending on criteria
    By Zyphon in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-30-2008, 12:00 PM
  2. using cell content to reference a worksheet tab name in second workbook
    By Conor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2007, 09:32 AM
  3. Printing PDF file with multiple worksheets- saving only first sheet
    By johnnywinter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2007, 01:03 AM
  4. Auto copying cells between worksheets
    By bpopilek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2006, 04:45 PM
  5. Sheet Lock
    By Rajkumar in forum Excel General
    Replies: 1
    Last Post: 09-14-2006, 05:14 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1