andyd25

I have been asked to setup a multi-user spreadsheet to record hours worked. Each user can only access their specific sheet and use a password to make changes. I then need the worksheet to automatically lock on closure. I have enabled Macros and added the following Sub ProtectALLShts() Dim Pwd Pwd = "1230" '<<< change password !!! For Each ws In Sheets If ws.ProtectContents = False Then ws.Protect Password:=Pwd End If Next ActiveWorkbook.Save End Sub I have then added Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Run "ProtectALLShts" End Sub It worked great for one test user. I then duplicated the first section with a seperate password and then got an error message when trying to close the spreadsheet. Run-time error 1004 Cannot run the macro ProtectAllShts. The macro may not be available in this workbook or all macros may be disabled. I have checked Developer Macro Security for Macro Settings and enabled Trust access to the VBA project object module. Any ideas or different way to setup a spreadsheet to record work hours appreciated.

Have done a search but not found anything on here. Can I have recommendations of preferably free MP3 file duplicator removal? Thanks

Is there an easy way of either list users in alphabetical order or export to csv. I have been asked to remove staff who have left and not been deleted

We just been asked to submit a HAR file

Have now been able to restore file View 5 worked. I can also switch back to classic view. Yes we backup 365 but much quicker to get access to their recycle or second stage bin

I used to be able to recover students deleted files by logging into 365 admin and creating a linking to access their files. This still works and I can see the students files and folders. Since Microsoft made changes I can no longer see or get access to the recycle and backup recycle bins. How can I restore files when the students have deleted their important coursework?

My iPhone 15 Pro has been delivered today as an early upgrade. Only ordered last night with EE