workbook save

Hello, Is there an effective way to prevent a user from changing the file extension of a file? For example, if a file needs to remain .xls I want to prevent a user from changing it to .xlsx, etc. I assume I would need to add code to the Workbook_BeforeSave event? Or is there a better way...

Hi, I have followed this forum for a while and found many great solutions to expand my VBA experience. However, I cannot find any solution to the following situation. I have a macro that downloads a .xlsx file and copy the worksheet to the users activeworkbook. If the user is working in an...

Hello, I've looked through many posts but I don't think I can find any for my problem (sorry if I'm wrong). I have a shared workbook that many people will be using (and probably at the same time). I have a few macros in the book that, when run, unshare the book, unprotect the particular sheet...

I need to a workbook in a specified folder, copy any sheet that contains "Dec" to a new workbook, save and repeat for all worksbooks in a folder Here is the code I have so far and it only opens all the files in the folder I specified but doesn't take the action to copy the sheets I have...

Hey guys, This may be a dumb question because I've been looking for an answer all over the internet and can't find the problem mentioned anywhere. I'm relatively new to Excel VBA though, and I'm trying to create two events for a single workbook. Is this possible? I have one workbook open...