full screen

So I have been having this same problem for a long time. I just work around it, by scrolling with my mouse, which can be tedious. We used to have MS 2016, now we have Office 365. Problem existed on both. The document is a shared document, old school, not the internet sharing because I need to be...

Cross-post ! So here is macro: Private Sub NoteZoom3() With ActiveWindow.VisibleRange NoteChangeSize .Width, .Height, True End With End Sub Private Sub NoteChangeSize(w!, h!, Optional scr As Boolean) With ActiveCell.Comment.Shape .Width = w: .Height = h...

Hi, I was wondering if there is an option/VBA code/steps that will automatically open a spreadsheet in full screen view and restrict users from toggling with the view unless a password has been entered. Pretty much the users will be using the spreadsheet only in full screen view while the...

Thanks for looking. My goal is to have a macro that will make the command bar hide and display the sheet in full screen. Also I would like a macro to undo all the above, but this macro would need a password to be executed. Here is some code that I found im just not sure how to put it all...

Hello All, So I have some code located in ThisWorkbook: Sub ApplicationDisplay() Dim cbar As CommandBar With ActiveWindow .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False .DisplayWorkbookTabs = False .DisplayHeadings = False...

I need help with a spreadsheet that I want to distribute widely. I put the introduction material and the instructions in 2 worksheets that do not look good. I would like to get rid of the menu bars. Since I do not want problems later, I do not want to reformat the text worksheets with macros...