Results 1 to 7 of 7

How to disable “Insert worksheet “ form tab ? except “input”,”output”, and “temp”.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    640

    How to disable “Insert worksheet “ form tab ? except “input”,”output”, and “temp”.

    Dear all , i have three worksheets “input”,”output”, and “temp”. here sheet “temp” is not visible . it is being created for processing some activity and after that it deleted during run macro. I want to implement below macro code sothat no one add new sheet except “temp “sheet. below code is working fine if “temp” sheet is not created by macro . how to implement some logic sothat it can ignore the “temp” sheet .

    'code by RoyUK
    Private Sub Workbook_NewSheet(ByVal Sh As Object)
        Application.DisplayAlerts = False
        ActiveSheet.Delete
        MsgBox "No new sheets allowed in this workbook", vbCritical, "User warning"
        Application.DisplayAlerts = True
    End Sub
    Last edited by nur2544; 01-29-2015 at 10:03 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Randomly sample 30 columns from worksheet input and print them in worksheet Output
    By Savan87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2012, 01:00 PM
  2. Input Sheet, Output Form - Can I do it?
    By GalFriday in forum Excel General
    Replies: 5
    Last Post: 08-27-2012, 09:01 PM
  3. Form to output input data into spreadsheet
    By kronos in forum Excel General
    Replies: 1
    Last Post: 06-23-2010, 01:03 PM
  4. Replies: 1
    Last Post: 06-23-2010, 07:08 AM
  5. format cell from data input to output form
    By Brad Stevenson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2005, 01:06 PM

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