Re excel

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
Hi!

Check thiz out.

HTH

thumbup.gif
 
Upvote 0
Hi and welcome to the board!!

This depends on what you mean. You can password protect your WS to prohibit changes in "Locked Cells". This will prevent users from changing or overwriting a formula. If you want to keep users from seeing a formula, choose Format>Cells>Protection Tab and select "Hidden". Once again, protect the WS. Now the formula will not show in the formula bar.
lenze
 
Upvote 0
lenze said:
Hi and welcome to the board!!

This depends on what you mean. You can password protect your WS to prohibit changes in "Locked Cells". This will prevent users from changing or overwriting a formula. If you want to keep users from seeing a formula, choose Format>Cells>Protection Tab and select "Hidden". Once again, protect the WS. Now the formula will not show in the formula bar.
lenze
Click to expand...

Thanks for that mate.
:)
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Hiding Sheets during the Before_Close Event
2
Replies
10
Views
291
Jaafar Tribak
Jaafar Tribak
A
  • Question
Password protect multiple excel sheet saved in same location by using VBA
Replies
3
Views
142
Micron
M
A
  • Question
VBA to run in Protected Workbook
Replies
5
Views
198
bobsan42
bobsan42
S
  • Solved
Hide Columns and password protect without locking cell
Replies
1
Views
397
Sergio
S
A
  • Question
Adding Password to Modify with and without Password to Open
Replies
0
Views
61
AC PORTA VIA
A

Forum statistics

Threads
1,214,943
Messages
6,122,380
Members
449,080
Latest member
Armadillos

Share this page

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
Back
Top