disable macros + others

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

I have an old spreadsheet from 2001, I haven`t a clue now how I constructed
it but would like if possible to do 3 things.

1. I have apparently put macros in it although what I don`t know and would
prefer to disable.
2. When I open the workbook that particular sheet is only approx quarter the
size of the workbook screen, I would like full size.
3. I apparently have a password on it, can I disable it? Haven`t a clue what
it is now.

thanks
 
I have an old spreadsheet from 2001, I haven`t a clue now how I constructed
it but would like if possible to do 3 things.

1. I have apparently put macros in it although what I don`t know and would
prefer to disable.
2. When I open the workbook that particular sheet is only approx quarter the
size of the workbook screen, I would like full size.
3. I apparently have a password on it, can I disable it? Haven`t a clue what
it is now.

thanks
Click to expand...

to diable macro click on tools--> macro-->security and click "low"
that will diable the macro
 
1. The biggest problem - if the password is a File Open password then google
for Excel Password Crackers. If the password is on a sheet - add a new sheet
and copy the contents of the protected sheet to the new sheet.
2. Disable macro - either delete them or hold down the shift key when you
open the file - the second way will be required each time you open the file.
3. Maximize the screen and then save the file. The file will open maximized
unless a macro is causing the screen to be small.
 
Back
Top