+ Reply to Thread
Results 1 to 3 of 3

Can you hide the worksheet view when using an input form?

  1. #1
    Registered User
    Join Date
    10-26-2012
    Location
    501 West 23rd Street
    MS-Off Ver
    Excel 2008 12.2.4 MAC
    Posts
    1

    Lightbulb Can you hide the worksheet view when using an input form?

    Greetings,

    I am a former (Windows) Excel user not working in the MAC world. I have a simple "contact list" and would like to create an input form but I would like to hide the worksheet view completely and disable the ability for anyone to change any existing data in the worksheet. Basically, just allow one to enter new data via the input form. I have searched and googled but can't find any resources to address it need. Any ideas out there?
    Thanks
    K

  2. #2
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: Can you hide the worksheet view when using an input form?

    Goto VBA screen
    Select the sheet you want
    in the properties window
    under properties
    select visibility, choose very hidden.
    If you then protect the workbook and VBA with a password this is the best way to stop anyone viewing/tampering with the data.

    Sean

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Can you hide the worksheet view when using an input form?

    if you are using excel 2008 I suspect you may be completely out of luck since vba is not supported
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1