So after you pasted the vba code in, you need to remove the empty line:. I have the same error. I have reviewed the responses to your original issue in regards to the syntax compile error and i still cant seem to fix the issue. I added the code to each of the worksheets but i still get that error.
Do you have any suggestions? Products 72 Special Topics 41 Video Hub Most Active Hubs Microsoft Teams. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Autonomous Systems. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work.
Small and Medium Business. Humans of IT. Green Tech. MVP Award Program. Video Hub Azure. Microsoft Business. Microsoft Enterprise. Browse All Community Hubs. Turn on suggestions. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Products 72 Special Topics 41 Video Hub Most Active Hubs Microsoft Teams. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Autonomous Systems. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. Small and Medium Business. Humans of IT. Green Tech. MVP Award Program. Video Hub Azure. Microsoft Business. Microsoft Enterprise.
Browse All Community Hubs. Turn on suggestions. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. And according to what it can do, we call it Workbook Unprotect Genius. Full version is recommended if you are sure to successfully unprotect your excel sheet in few seconds.
And then click Open button on iSunshare Workbook Unprotect Genius to browse and select it in your computer, then add it to iSunshare software with "Open" button.
Tap on Remove Password button now and sheet password, workbook protection password and read-only password would be removed from excel file simultaneously, supposing your excel file is protected with all of these passwords. Click OK and you would get an unprotected excel file, which contains your unprotected worksheet.
Get a excel file, and make it a copy it. Open one, and password protect the sheet and workbook. Thanks for your additional help, hope we could help the user with it too. Copy sheet into New Tab, Paste so looks exactly like sheet copied password protect did not copy over to new sheet , double check matches data in prev sheet. Delete original sheet and rename copied one same as original. Password Protect this new sheet if you wish making sure you 'write it down' ; -.
NikolinoDE I have a file of one sheet that I would like to unlock, could you help me with that please? Hi Nikolino, I can see you have been able to assist with Excel Spreadsheets with forgotten unprotect passwords. I have the same issue as I created a spreadsheet months ago, have not looked at it since and I've now forgotten the password.
Would you be able to assist with recovering the password? If it is a matter of removing not retrieving a Worksheet password, the following code may be used:. Patrick Could you elaborate? That operation in your new workbook will have lost all features used by Excel versions after Excel You then need access to a computer running a version of Excel before Excel and preferably as early as Open also the file I attach to this post.
That file can run on later versions of Excel but doesn't work on Excel , or Excel , or I think it might work with a bit of a 'glitch' on It does work on and before. I wrote an explanatory document on including the code used this in Word and I attach that for your assistance. The disadvantage is that you lose all features from later versions of Excel but you will generally, at least, have back access to all your data and that, indeed, might well be your lifesaver.
Old versions of Excel are still available on Ebay etc. But they really need installing on a computer without any later versions of Excel on it or using a Virtual machine approach.
Hope that helps. Sorry I haven't tested it as I don't have access to an ancient version of Excel at present and don't run a Virtual Machine. Products 72 Special Topics 41 Video Hub
0コメント