Store sheet settings

[Stevenn]

I have a workbook to administrate a budget. When I startup my workbook I adjust some settings, e.g. budget_id. What is the best way to store these settings? Is it best to have a worksheet to store these settings with some named ranges and get and set with Range("budget_id").Value or is there another way to do this? Maybe in the ribbon?

 

[Weaver]

Sorry, not sure what you mean by "When I startup my workbook I adjust some settings, e.g. budget_id."

Do you mean that budget_id represents a named range and it is this reference and/or the range it refers to that you have to edit each time you open the workbook?

I ask this because 'budget_id' isn't a 'sheet setting' in the sense that I understand, afaik.

 

[Stevenn]

Sorry, not sure what you mean by "When I startup my workbook I adjust some settings, e.g. budget_id."

Do you mean that budget_id represents a named range and it is this reference and/or the range it refers to that you have to edit each time you open the workbook?

I ask this because 'budget_id' isn't a 'sheet setting' in the sense that I understand, afaik.

Oh. I did not mean specific worksheet settings. I mean settings which is relevant to my budget. The kind of settings i want to store is "Budget ID", "Budget name", "Deadline date" and such. So when I say I adjust the settings when i startup the worksheet, I mean that I can start a new budget in the worksheet, and I want to adjust some settings for the specific budget. I hope it's understandable