vbaproject

Hi all, I Have recently written this piece of code so I just thought I would post it here for future reference should anyone be looking for vba code to lock\unlock a vbaproject programmatically without needing to use the unreliable SendKeys method. workbook example This code requires that the...

Hello all you MrExcel experts This concerns my posting #5 & #6 in a thread started by Hitbid called ‘Question about optimizing simple code’ dated Nov. 3, 2018. The link to this is: https://www.mrexcel.com/forum/excel-questions/1076409-question-about-optimizing-simple-code.html I had offered...

Hi, If I have two Workbooks open with macros in each, and I close one Workbook, why do I still see the macros for the closed workbook in the VBAProject list? After a while it closes but how do I get it to refresh the list or close the Project with the Workbook closure so I don't get confuse...

Hi all, I wonder why my VBAProject Explorer shows some worksheet that does not exist in my workbook... :confused: What when wrong? I'm sure no sheet is hidden..... I see Sheet1 (Sheet1) thru Sheet5 (Sheet5) on this explorer and I can't find these spreadsheets in my workbook... Also I have one...

My environment is XP running office 2007. I am developing an excel application using VBA forms. everything works fine, no errors, until I protect the VBA project. When I protect it, I close and save the workbook and then re-open it. Many times it works the first time I open it and fails on the...

hello frd i need your help i have one excel sheet which have some data with vba code but i forget the password in vbaproject can any body help me to sort out this matter pls plss help mee thanks in Advance

We are evaluating Office 2011 for Mac. I have an XLAM file which requires a password to open. It opens with that password in Excel 2007 (on a PC). The same password is rejected when I try to open a copy of the XLAM file in Office 2011 for Mac. (Yes, I did check CAPS LOCK.) The response is...

Hi, Thoughts please... Note: To keep to forum rules, i am not asking how to crack passwords, nor specifics of methods on how to. I was wondering how strong the passwords which protect VBA projects are. I know things like protected sheets can be broken easily by running a piece of code...