• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Enable Editing Option

A

Abhijeet

Active Member
Hi

I have Day wise sheets in excel file & Today's date prior all sheets are automatic protect through macro but still few users are updating prior dates sheets i thing when excel file open that time show enable editing option before click in to that sheets are not protect after click on that then protect can any one tell me how to avoid this thing i want when any user can open file that time all prior dates sheets are protect & hide through vba like this
Code: 
Sub HideSheet()

    Dim sheet As Worksheet

    Set sheet = ActiveSheet

    ' this hides the sheet but users will be able
    ' to unhide it using the Excel UI
    sheet.Visible = xlSheetHidden

    ' this hides the sheet so that it can only be made visible using VBA
    sheet.Visible = xlSheetVeryHidden

End Sub
 
@Abhijeet
If every user uses this file with own profile or ID,
You could name for sheet which users can edit it ( everybody else don't)?
 
Hi

No Each user separate file but each file Day wise sheets i want to protect today's date prior all sheets i want protect i have that macro but if enable editing option show then that time they can edit that is challenge for me please tell me
 
@Abhijeet ... long sentence.
Could You write 'step-by-step', only one sentence by step? like...
1) user opens own file
2) user has 10sec time to edit
3) protection goes on
or
what kind of idea do You have?
 
Hi Vletm

1)User open own file
2) After open file then enable editing option is pop up
3) If user can click on that pop up then sheet is protect if not then they can edit
4) I want to avoid this thing no one can edit sheet prior to today's date sheets

i know this opetion is disable then this problem solve but each user i want to do this setting is any way that macro can do this setting
 

Attachments

  • Picture32.png
    Picture32.png
    71.1 KB · Views: 8
  • enable-editing-3.jpg
    enable-editing-3.jpg
    77 KB · Views: 9
yes i read this link but unable to understand when excel is run then this pop will ask if we select yes then these option are turn off is this
 
@Abhijeet
The script needs to be executed when Excel is not running.
The new settings will be applied the next time Excel is run.
I hope that someone else have an idea ...
 
If you are in good terms with your IT department. Get them to use Group Policy Object (GPO) to enforce Office/Excel settings to all computers belonging to security group and/or domain.
 
Unless they change it or it's controlled by IT security setting. It should remain in place.

That's why I suggested GPO.
 
You must log in or register to reply here.
Back
Top