Stop macro from moving to front page on save

**EuEra** · 11-13-2014, 08:12 AM

Hi there guys i have a really frustrating issue, i have a spreadsheet here that has a load of annoying protection on it, im a complete noob but have somehow managed to unlock the vba and remove some protection but im stuck and might of caused some damage. Whenever i click a button or try to type something in the calandar hides all sheets and takes you to the log in sheet which is now no longer working. I need help stopping it from hiding everything and calling the start sheet and i need to remove the need for the start sheet entirely. I would really appreciate help here thanks guys. Here is the link to the spreadsheet removed by Admin

EDIT:A moderator closed this last time which i dont think is fair because its not cracking protection, there is no protection on the sheet except it forces a page everytime you save which i want to remove.

**Kenneth Hobson** · 11-13-2014, 09:49 AM

Please use more descriptive text in your subject line.

The file looks cracked to me or just obfuscated on purpose to stop modification or reverse engineering. Othwerwise, I would tell you how to figure out how to break the selection event issue. The variables and modules are all obfuscated so even if you broke or stopped that part from firing, reading the code for what it does for other things makes no sense. Looks like the author used an obfuscating routine for the vba code and module names or the cracking code did that.

**EuEra** · 11-13-2014, 09:59 AM

Hey thanks for replying, sorry im a total noob at this so dont really understand what you said

. Is it possible to remove the log in sheet and have the spreadsheet function properly?

**JBeaucaire** · 11-13-2014, 06:23 PM

I've removed the link to your external workbook due to the nature of the content in the ThisWorkbook module and references to cracking VBA passwords found in that code. Please understand it's not personal, we do not allow such content, nothing more.

As for your question, if you want the workbook to stop doing something when you save the workbook, remove the Workbook_BeforeSave macro from the ThisWorkbook module. That will certainly stop that behavior.

**EuEra** · 11-14-2014, 04:59 AM

Hi no worries i totally understand, ive learned a new term, obfuscated. It looks like this spreadsheet is obfuscated lol, are there any signs to look out for to find the before save macro, some of the code is readable and gives hints as to its functions.