Resolved. Thanks to all who helped.
Printable View
Resolved. Thanks to all who helped.
Hiding the menu bar.
Check out the commandbars - reference the office 8 or 9 in vba code to access.
Black outline... dunno - property of the sheet perhaps?
Vince
Application.ActiveSheets.AnnoyingBlackOutline.Visible = False?
:confused:
I still don't know what to do. Can anybody help me?
The only way I know of hiding the outline is to protect the worksheet but cells can't be selected by the user. This may or may not be a problem to you.
Maybe try the excel newsgroup at M$ for an alternative?
Don't know how to get rid of the outline, but the follwing code will get rid of the - "lil box in the bottom right hand corner that allows you to repeat the formula"
VB Code:
Thanks for all your help everyone. I have now finished the assignment with credit, possibly distinction. Much appreciated.
Dont forget to edit your original post with Resolved (or the
green checkmark) if this issue is solved.
:)