Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-07-2007, 05:57 AM   #1
scott-atkinson
I'm with the Witch.......
 
scott-atkinson's Avatar
 
Join Date: Aug 2006
Location: West Midlands, (Formally Essex Barrow Boy....)
Posts: 1,584
Thanks: 25
Thanked 29 Times in 26 Posts
scott-atkinson will become famous soon enough
Protecting a chart but allowing chart data to change?

Guys,

I have another issue.

I have a chart with macro buttons on which toggle between data that the chart presents.

How can i protect the sheet so the user cannot delete the buttons or chart but allow the chart to toggle the data?

__________________
As you slide down the banister of life, may the splinters never point the wrong way.
scott-atkinson is offline   Reply With Quote
Old 09-07-2007, 06:11 AM   #2
unmarkedhelicopter
Registered User
 
unmarkedhelicopter's Avatar
 
Join Date: Apr 2007
Posts: 177
Thanks: 0
Thanked 0 Times in 0 Posts
unmarkedhelicopter is on a distinguished road
Post example sheet
__________________
The Rotors have Stopped ! ... Is that a bad thing ?
2 + 2 = 9, My Arithmetic is Mental
unmarkedhelicopter is offline   Reply With Quote
Old 09-07-2007, 06:18 AM   #3
scott-atkinson
I'm with the Witch.......
 
scott-atkinson's Avatar
 
Join Date: Aug 2006
Location: West Midlands, (Formally Essex Barrow Boy....)
Posts: 1,584
Thanks: 25
Thanked 29 Times in 26 Posts
scott-atkinson will become famous soon enough
Quote:
Originally Posted by unmarkedhelicopter View Post
Post example sheet
Chart.

Attached is a screen shot of my chart, I want to be able to protect the chart and buttons from being deleted but allow the data to be toggled.
Attached Images
File Type: jpg Chart example.jpg (64.6 KB, 121 views)

__________________
As you slide down the banister of life, may the splinters never point the wrong way.
scott-atkinson is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the data source on a chart in excel us vb wavp Modules & VBA 4 11-07-2005 06:35 AM
[SOLVED] Show % values with one decimal place in CHART DATA TABLE jjafer Reports 2 04-13-2005 12:29 AM
Allowing further data entry in populated field WWolfe Forms 3 12-09-2002 07:14 AM
query sending too much data to chart knzass Reports 2 11-06-2001 07:01 PM
[SOLVED] data change on combo selection karmawangdi Forms 2 05-25-2001 02:15 AM




All times are GMT -8. The time now is 07:47 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World