Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 26-11-2009
Member
 
Join Date: May 2009
Posts: 3,613
Hidden parameter but modifiable

I have an Excel file with 3 tabs and a menu that can launch a macro. This macro creates a new file with data extracted from the first file (creates statistics).

Now, for various reasons, I will have to put a password to access the macro code, and put a password to use the macro statistics.

The first file must be changed (in the data in the tabs). But I can not add these tabs. But I want the names of the charts in the second file (generated automatically by the macro) that are configurable. So, how to store these names without putting them in sheets?
Reply With Quote
  #2  
Old 26-11-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: Hidden parameter but modifiable

It changed without adding information. Will you be a little more explicit (descriptive) to your problem. To store the names of the charts or any other object, you store a variable in your procedure for him which then reflects in the Name property. Not before or was the concern.
Reply With Quote
  #3  
Old 26-11-2009
Member
 
Join Date: May 2009
Posts: 3,613
Re: Hidden parameter but modifiable

The goal is that you open yourselves the first file, you change the name of a chart for generating the second file. Then, you save both files. You reopen the first, and miraculously, the name has been registered for the next generation of graph. Except that I do not want to store the name of the chart in the first file, or store it in a worksheet.
Reply With Quote
  #4  
Old 26-11-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: Hidden parameter but modifiable

Sorry but I do not understand still. Or a thing must have been missed. You create your file 1. Your macro created the 2nd file with the proper name of the graph by the name of the graph in the first set? Or, if you need to store the name somewhere you can use an invisible sheet and store it, or an external text file (txt, ini etc.). Your generation of graph, as you say, it's done by the macro or you made it manually?
Reply With Quote
  #5  
Old 26-11-2009
Member
 
Join Date: May 2009
Posts: 3,613
Re: Hidden parameter but modifiable

I do the macro, and someone else uses it. It is that someone else does not detect things configurable, and that for him, nothing changes from before. (because some people have the right to run the macro (those who have the password), and not others).

So, for those without access to the macro, they should not see the setting.
For those who have access to the macro, they must be able to change the settings, but it must be recorded in the first file. Generate parameters once, and if it is, you do not ever change. But it must if the user wants to change the name (of the graph generated in the second), the name is stored in the first file, so the next time they use the macro, the name reappears.

About passwords, I do not know if it's great. I thought I read that it was easily crackable (well, we can remove the password, and not find them). So is there a way to hide a macro?
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Hidden parameter but modifiable"
Thread Thread Starter Forum Replies Last Post
Hidden Chronicles game is freezing and unable to collect hidden items in library Bhuvanlal Video Games 6 26-01-2012 03:26 AM
Why is there a key hidden in every scene of Zynga Hidden Chronicles? M@ndy Video Games 4 25-01-2012 04:58 PM
JSF example url? Parameter Help!! Gadin Software Development 5 21-09-2010 10:05 PM
Files Remain Hidden Even though I selected show Hidden & Protected LabTechnician Vista Help 9 07-05-2007 01:32 PM


All times are GMT +5.5. The time now is 07:21 AM.