+ Reply to Thread
Results 1 to 15 of 15

EXCEL: Problem With New Sheet Addition - Without Code

  1. 05-27-2013, 08:03 AM #1
    [email protected]
    gaikwad.mm@gmail.com is offline
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    EXCEL: Problem With New Sheet Addition - Without Code

    Dear Experts

    Need help with the following scenario.

    1] I' am having an Excel file with 5 Sheets.

    2] All Sheets are having some Data Validations as well as few Formulas and some restrictions with VBA Code.

    3] I' am allowing user to insert Sheets as they required for some other information process [hence can't disable sheet addition]

    PROBLEM STARTS HERE

    4] As my file contains 5 sheets i.e. A, B, C, D & E. all having Codes & Data Validation

    5] User Inserts New 5 Sheets, Copied existing 5 Sheets format in the New Sheets

    6] Deleted existing Sheets & Rename the New Sheets as Old 5 Sheets.

    7] The sheets which are newly inserted are not having any Codes,

    8] User can do anything in those sheets without any Codes and restrictions.

    HOW TO AVOID THIS?

    Any help will be appreciated
    Reply With QuoteRegister To Reply
  2. 05-27-2013, 10:45 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,467

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    I would suggest that you lock the workbook down, sheet passwords, workbook structure password, VBA Project password, etc.

    Then provide a button and macro that creates a new worksheet. So, the only way to create a new worksheet is under your control.

    Can't think of any other way.

    Alternatively, address this as a disciplinary issue: return the adulterated workbooks to the individual and tell them that it is not acceptable practice. Send them a new copy of the original and tell them to re-input any information using *your* workbook.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 05-27-2013, 12:09 PM #3
    [email protected]
    gaikwad.mm@gmail.com is offline
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    Hey TMShucks

    Thanks for your reply...,
    but the problem remains same....,
    even if I' control the sheet addition ..
    it will be created without Codes...
    and I' want to avoid it
    Reply With QuoteRegister To Reply
  4. 05-27-2013, 12:23 PM #4
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    Check this out
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  5. 05-27-2013, 02:10 PM #5
    [email protected]
    gaikwad.mm@gmail.com is offline
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    Thanks XLADEPT: But still my requirement is different from this.
    Reply With QuoteRegister To Reply
  6. 05-27-2013, 03:32 PM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,467

    Re: EXCEL: Problem With New Sheet Addition - Without Code 

    Please Login or Register  to view this content.

    Regards, TMS
    Reply With QuoteRegister To Reply
  7. 05-27-2013, 03:47 PM #7
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,467

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    but the problem remains same....,
    even if I' control the sheet addition ..
    it will be created without Codes...

    The intention is that you switch off copy and paste and prevent moving and copying worksheets except under your control. So, the user cannot copy your existing sheet, nor can they copy the contents of your sheet. If they want/need a copy of your sheet(s), they can only get one by using the button/macro that you provide.


    Regards, TMS
    Reply With QuoteRegister To Reply
  8. 05-27-2013, 04:05 PM #8
    [email protected]
    gaikwad.mm@gmail.com is offline
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    Sorry TMShucks

    But this is not what I' requested.

    User can just insert a new sheet

    copy the content from another sheet in new sheet..

    how should we prevent the same.
    Reply With QuoteRegister To Reply
  9. 05-27-2013, 04:18 PM #9
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    Not many would manually copy any significant amount of data - are these data small in number?
    Reply With QuoteRegister To Reply
  10. 05-27-2013, 04:26 PM #10
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,467

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    See the attached sample workbook.

    When you open it, you will not be able to insert, delete, rename, copy or move a worksheet. Nor will you be able to cut, copy or paste within the workbook. If you switch to another workbook, you will be able to do all those things.

    Regards, TMS
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 05-28-2013, 02:48 AM #11
    [email protected]
    gaikwad.mm@gmail.com is offline
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    That I' understood my Friend, But please you go through #1 Comment posted by me to understand the actual requirement.
    Reply With QuoteRegister To Reply
  12. 05-28-2013, 03:21 AM #12
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,467

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    OK, I give in. You don't want them to mess with your workbook, then either tell them that they must not mess with your workbook or you stop them from messing with your workbook.

    This is not an "off the shelf" solution, it is something that you can take and adapt, if you so wish.

    You could, for example, choose to stop them deleting or renaming sheets so that they cannot try to pretend they are sending back what you gave them.

    Your choice, but I'm out now.

    Regards, TMS
    Reply With QuoteRegister To Reply
  13. 06-03-2013, 03:15 AM #13
    [email protected]
    gaikwad.mm@gmail.com is offline
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    -


    still waiting for solution


    -
    Reply With QuoteRegister To Reply
  14. 06-03-2013, 01:20 PM #14
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    What's wrong with TMS' solution Post#10 - Did you even try it? Why don't you just command them to refrain from that ignominous behavior
    Reply With QuoteRegister To Reply
  15. 06-04-2013, 04:08 AM #15
    [email protected]
    gaikwad.mm@gmail.com is offline
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    Re: EXCEL: Problem With New Sheet Addition - Without Code

    Hi xladept

    I' don't want to lock all the functions mentioned in the #10
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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