Microsoft Office Forums protected cells

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2019, 12:59 AM
tofimoon4 tofimoon4 is offline protected cells Windows XP protected cells Office 2003
Novice
protected cells
 
Join Date: Mar 2012
Posts: 13
tofimoon4 is on a distinguished road
Default protected cells


Dear sir with my regards asking you kindly for help by creating two buttons for protect & unprotect the cells which have formulas in attached file .
Thanking you >
Attached Files
File Type: xltm file.xltm (16.6 KB, 6 views)
Reply With Quote
  #2  
Old 05-24-2019, 11:20 PM
tofimoon4 tofimoon4 is offline protected cells Windows XP protected cells Office 2003
Novice
protected cells
 
Join Date: Mar 2012
Posts: 13
tofimoon4 is on a distinguished road
Default

Dear sir any hope to get any reply .
Reply With Quote
  #3  
Old 05-25-2019, 05:40 PM
Alansidman's Avatar
Alansidman Alansidman is offline protected cells Windows 10 protected cells Office 2019
Novice
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 24
Alansidman is on a distinguished road
Default

Looked at your file. Don't see any formulas. Apparently you have developed some means to hide the function bar that would allow them to be visible.
Reply With Quote
  #4  
Old 05-25-2019, 11:44 PM
tofimoon4 tofimoon4 is offline protected cells Windows XP protected cells Office 2003
Novice
protected cells
 
Join Date: Mar 2012
Posts: 13
tofimoon4 is on a distinguished road
Default

Dear sir this is the way to protect the cells and formulas from seeing and deleting by a code .
What i need to do some changes in the code by putting ( 2 buttons ) to active and not active the code .
Thanking you.
Reply With Quote
  #5  
Old 05-26-2019, 02:32 PM
Alansidman's Avatar
Alansidman Alansidman is offline protected cells Windows 10 protected cells Office 2019
Novice
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 24
Alansidman is on a distinguished road
Default

Ok. Understand now. Helps if you are clear in your initial request. See the attached w/s
Attached Files
File Type: xltm file.xltm (25.8 KB, 6 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formating all cells in an array based on adjacent cells deejay Excel 6 12-20-2016 12:00 PM
protected cells Protecting a document; allow sections to be edited - spacing in table cells when protected dwciardi Word 3 09-30-2015 01:03 PM
protected cells Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
Unable to "Shift cells down" on unprotected area in a protected worksheet ricky0309 Excel 0 08-14-2014 01:51 AM
Copying text range of cells to different cells adds an extra line jpb103 Word VBA 2 07-23-2014 12:22 PM


All times are GMT -7. The time now is 10:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft