The Return of "Lochinvar" - Resolved

[RadarListener]

Resolved. Thanks to all who helped.

[Ecniv]

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

[RadarListener]

Application.ActiveSheets.AnnoyingBlackOutline.Visible = False?

:confused:

[RadarListener]

I still don't know what to do. Can anybody help me?

[DavW]

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?

[NeedSomeAnswers]

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"


Application.CellDragAndDrop = False

[RadarListener]

Thanks for all your help everyone. I have now finished the assignment with credit, possibly distinction. Much appreciated.

[RobDog888]

Dont forget to edit your original post with Resolved (or the
green checkmark) if this issue is solved.

:)