+ Reply to Thread
Results 1 to 2 of 2

Potential protected sheet bug ?

  1. #1
    Registered User
    Join Date
    03-06-2020
    Location
    canada
    MS-Off Ver
    365
    Posts
    7

    Potential protected sheet bug ?

    So I am trying to prevent future users from HIDING ROWS, and instead be able to DELETE rows. As I Understand it, unchecking the Format boxes and checking the delete boxes should allow me to do just that :
    image_2023-04-24_105944203.png


    Sadly it appears that unchecking the format boxes ALSO disables the deleting of said rows. Asking chatGPT it seems there used to be HIDE ROWS boxes in previous versions... but for now this is where I'm at

    image_2023-04-24_110241444.png

    Any idea of a solution ? Chat GPT Proposed a VBA script but it doesn't work well

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.EntireRow.Hidden Then Target.EntireRow.Hidden = False
    End Sub

  2. #2
    Registered User
    Join Date
    03-06-2020
    Location
    canada
    MS-Off Ver
    365
    Posts
    7

    Re: Potential protected sheet bug ?

    Unless I am not making the script fire correctly ? I ahve to say I'm not very familiar. When right click on the tab and click view code the cript is there though. Are there other steps?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 07-28-2014, 06:35 PM
  2. [SOLVED] bug on the macro coded sheet, a protected sheet, every time i made an action i wanted
    By dondonordas in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-22-2014, 06:46 AM
  3. Replies: 1
    Last Post: 02-22-2014, 01:28 AM
  4. vba changing sheet tab color when it was protected/not protected
    By mcmunoz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2013, 05:39 AM
  5. [SOLVED] Copy protected sheet to a NEW workbook that is not protected
    By lsteinbach in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-14-2012, 11:50 AM
  6. Delete rows in a protected sheet with protected cells
    By Maranwe in forum Excel General
    Replies: 7
    Last Post: 10-31-2011, 08:12 AM
  7. Protected Sheet not protected from Copy Paste
    By twistedsymphony in forum Excel General
    Replies: 4
    Last Post: 04-19-2010, 05:37 PM

Tags for this Thread

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