protected

I'd like to ask for VBA to unprotect my sheet, cells i cant write to, password protected but dont have password.

All, thank you for taking a look at this question. I have read some past questions and answers here on Mr.Excel from 2008 about how marcos/vba will not run on a worksheet(s) protection when shared. Here is a past comment, I discovered this characteristic about Excel 2007 shortly after our...

The event is triggered just fine when the worksheet is not protected. When I protect it, however, this event is no longer being triggered. Nothing else has changed. Is this how Excel is supposed to work? Not sure if I'm missing something here...

Hi, I was hoping to use the outline button to allow users to expand some fields in a spreadsheet on share point. But the sheet opens in excel online where VBA is not allowed. The only way I know to use the group(+) on protected sheets is via a macro. Has this been resolved or addressed on...

Hi The below code runs as part of a Workbook Open event Sub Fillcell(Color As Long, cValue As String) Application.EnableEvents = False With Selection .Font.Name = "Wingdings" .Font.Size = 12 .Font.ColorIndex = 1 .Value = cValue If...

I have a line generating an error "Subscript Out of Range"Windows("annualof.xls").Activate I've run the macro before successfully, but am now trying to run the code on a new machine with a newer version of excel (2019). I have the file open, but receive an error. The workbook "annualof.xls"...

This issue is a bit difficult to explain. Essentially I'm having issues finding shared & protected workbook settings that fit my teams need. Requirement: 1. I need this file to be shared so multiple people can go in at the same time and make changes to un-protected cells. 2. ALSO need this...

I have a protected Worksheet and when I am testing it out I have no problem copying the worksheet to a new workbook. When a user opens the same workbook\worksheet. When he clicks RMB on the tab to tries the same maneuver everything is greyed out. He has to unprotect the sheet to copy the...

I have a spreadsheet with dates in R3:CE3 . I was looking to have this auto lock the cells from edit anything two days prior to today's date. Columns A:Q are protected when I protect the sheet. R:CE are the only columns you can edit. Hopefully someone can help me out on this. Appreciate the help.

Dear All, I occasionally get data files scraped from the web. They come in protected view and it is easy to manually enable editing so I can use the data. I would like to use those few manual keystrokes in a macro. The recorded code is: ActiveWindow.ActivateNext...

Hello, I am new to this forum along with being new to Userforms and codes. I have set up an Excel Userform, with 3 tabs at bottom of workbook. Mgmnt Ticket, Ticket Data Entry, and LookUpLists 1) Mgmnt Ticket - Password Protected but can not get the code to get through the password. If I...

Hi All, When I scrape a file from the web it comes in "protected view". When I use the recorder for this being unprotected. I get: application.activeprotectedview.edit=false. When I run this on a new file I get run time error 91. Not sure exactly what object I'm supposed to define and set. Help...

Hello All, I am having trouble with passwords hoping its a simple fix. I have four sales teams of 5 people who each have their own commission sheet which are password protected to open. The team leads sheet has links to cells in each of his team. So when the team lead opens their file it is...

I have a protected spreadsheet (without password) that has subtotals and the associated group levels. These cannot be expanded or collapsed when the sheet is protected. I have found threads that deal with this and advise the following solution: In the code for the sheet, put the following...

I have a button that's supposed to alphabetically sort a table by the first column so the end user won't have problems finding employees even when the worksheet is protected. Unfortunately the code that I have and that worked fine when I first tried it won't stop returning a run time 1004...

Hi All I have the following macro assigned to a macro button which refreshes 2 hidden pivot tables from a protected worksheet and brings back the refreshed data; Sub Refresh() ' Refresh Macro Worksheets("Pivot").PivotTables("PivotTable1").PivotCache.Refresh...

I am developing an application which in which the sheet acts as a list box to select Items (using either the "Enter" key or double click, and open a userform for editing, I have it set up to high light the entire row. Now my issue are that with out protecting the cells entries can still be...

Hello! I am an intermediate excel user who is designing a large file which will be used by many people. I cannot tell you more then that. I would like for users to be able to group/ungroup columns and rows on protected worksheets. Initial research tells me this requires VBA skills that I am...

Hi All I am hoping that someone can help me. I am attempting to open an excel file which needs a password at start up. I have tried using the code below: "Sub OpenWbWithPassword() Application.DisplayAlerts = False Workbooks.Open Filename:="S:\Site\Training...

Hello! I need to open a protected book reading a BAT file, in a silent way, without messages or alerts. Perhaps including the pwd as a parameter in the command line but I couldn't find how to do it. Thanks in advance.