Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-06-2013, 02:28 PM
omahadivision omahadivision is offline Way to lock a workbook but still allow moving datapoints on a chart? Windows 7 32bit Way to lock a workbook but still allow moving datapoints on a chart? Office 2007
Novice
Way to lock a workbook but still allow moving datapoints on a chart?
 
Join Date: Oct 2012
Posts: 28
omahadivision is on a distinguished road
Default Way to lock a workbook but still allow moving datapoints on a chart?

Hello,



I am trying to write a macro to make my excel workbook read-only. This would be fairly easy, except that I still want users to be able to move and delete datapoints on a series on a chart, and I want users to still be able to run macros. I don't want data changed or the chart edited in other ways such as resizing or renaming the axises. Optimumly, I could also make it non-read-only by running another macro. How could I make a read-only exception for data labels?

Thanks!

-Dave
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Way to lock a workbook but still allow moving datapoints on a chart? #REF! error when opening a workbook that contain a refference to another workbook tanababa Excel 2 06-07-2012 03:11 PM
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? tinfanide Excel Programming 1 02-09-2012 04:08 PM
Way to lock a workbook but still allow moving datapoints on a chart? macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM
Way to lock a workbook but still allow moving datapoints on a chart? Moving formula range multiple cells when moving sum over one cell FraserKitchell Excel 4 02-26-2010 10:38 AM
Way to lock a workbook but still allow moving datapoints on a chart? Select a range in one one workbook while working in other workbook Slow&Steady Excel 1 02-21-2010 03:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:16 AM.


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