Make excel look nothing like excel?

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,169
Office Version
  1. 2013
Platform
  1. Windows
Hi all

I am just wondering if anyone has any tips an tricks concerning making excel not look excel.

Ive created a worksheet which will be used a lot i want it to look as little like excel as possible.

In the workbook open event i have a few line to make it a full screen and remove gridlines, any other suggestions greatly appreciated.

In particular is there code so i can remove every menu from excel but....I only need the user to be able to do a file save??....


Thanks for your input, i appreciate it (As always)
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Lewiy

Well-known Member
Joined
Jan 5, 2007
Messages
4,284
Sheet tabs, scroll bars, formula bar, status bar, row & column headers, etc. are all things that can be turned off in Tools>Options>View. Some of these can just be turned off for the particular workbook you are using so there’s no need for coding them in.
 

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274
You can even turn off the toolbars. Toolbars can be customized very extensively according to ur needs.
 

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,169
Office Version
  1. 2013
Platform
  1. Windows
Hi thanks for the replies

If i remove all the toolbars will it do it just for that workbook?

I dont want to lose all my toolbars when i open up a new instance of excel.

Thanks
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
What you can do is record a macro while you manually turn all the "stuff" off.

then you can add that code to your Workbook_Open code..

make sure to create a workbook close code to turn it all back on. Users really hate it when you take away toolbars and don't put them back......
 

Forum statistics

Threads
1,181,362
Messages
5,929,534
Members
436,676
Latest member
Mavri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top