Disabling the Sheets Unhide feature in Excel

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • AllusiveKitten
    New Member
    • Feb 2007
    • 43
    #1

    Disabling the Sheets Unhide feature in Excel

    Hi All

    I dont know if it is possible or not, but I am wondering if anyone knows if you can Disable the Unhide feature in Excel. The feature I am talking about is found under Format > Sheet > Unhide.

    If this is possible I would love to be able to code this in..... it will keep little fingers from not touching what they shouldnt be.

    Thank you for your assistance.
    AK
    Tags: None
    • vinci
      New Member
      • Aug 2006
      • 62
      #2
      Disabling the "Unhide"?
      Is the Sheet visible when the excel file will be opened?
      because i think that when the sheet is visible the Unhide function will be definitely disabled...

      Are you trying to say that you want the Unhide function disabled when the sheet is hidden?

      cheers!

        Comment

        • AllusiveKitten
          New Member
          • Feb 2007
          • 43
          #3
          Hi Vinci
          Originally posted by vinci
          Disabling the "Unhide"?
          Is the Sheet visible when the excel file will be opened?
          No the sheets are not visible, I have the sheets hidden when excel opens, I have commands the user presses to enter their password before the sheet will become visible.

          Originally posted by vinci
          Are you trying to say that you want the Unhide function disabled when the sheet is hidden?
          Yes I am trying to say I want the Unhide function diabled when the sheet is hidden, I want the Unhide function disabled when this paticular spreadsheet is opened full stop..

          Hope this helps

          Cheers
          AK

            Comment

            • vinci
              New Member
              • Aug 2006
              • 62
              #4
              i think its impossible...

              let me first try with my aplication...


              but if you were able to disable it, let me know! thanks... :D

                Comment

                • AllusiveKitten
                  New Member
                  • Feb 2007
                  • 43
                  #5
                  Originally posted by vinci
                  i think its impossible...

                  let me first try with my aplication...


                  but if you were able to disable it, let me know! thanks... :D
                  Hi Vinci,

                  I have had no luck in working it out, your help would be greatly appreciated.

                  Thank you
                  AK

                    Comment

                    • Tequilaman
                      New Member
                      • Oct 2007
                      • 43
                      #6
                      By protecting the workbook completely the unhide is disabled as well. Just make sure that you have not locked the cells the user should work on.

                        Comment

                        • AllusiveKitten
                          New Member
                          • Feb 2007
                          • 43
                          #7
                          Originally posted by Tequilaman
                          By protecting the workbook completely the unhide is disabled as well. Just make sure that you have not locked the cells the user should work on.
                          Thank you Tequila, that works a treat.
                          AK

                            Comment

                            Previous template Next
                            Working...