Question from A Newbie
 

I currently have a Workbook that has 32 different worksheets. Here is
my goal for this workbook and I'm hoping someone out there would be
able to explain how I would accomplish it. I am new to this whole
concept. I have no knowledge of VBA or programming with excel. I do
know some C++ but I doubt this will help with this.

GOAL: I would like when the user opens the workbook it would prompt
either with a box that will allow them to check which one they need to
edit or with a drop down box that they can select from. After making
the choice they would select OK and it would then display the correct
worksheet and keep the rest hidden from view. I would then like a
button that they could click to save the file to the same location
everytime no worrying about overwritting the original.

Please let me know if there is anyone that can help.


--
akafrog18
------------------------------------------------------------------------
akafrog18's Profile: http://www.excelforum.com/member.php...o&userid=32876
View this thread: http://www.excelforum.com/showthread...hreadid=526792

Question from A Newbie
 

Sounds more like a project (which is what many of us do for a living)
instead of a specific question to a specific problem. What you want can be
done with a workbook_open macro in the ThisWorkbook module using an input
box to unhide the sheet desired.
Or you could use a menu sheet with the names of the sheets in cells and a
double click event macro to unhide and goto the sheet desired. Or a
dropdown. Or?

--
Don Guillett
SalesAid Software

"akafrog18" wrote
in message ...

I currently have a Workbook that has 32 different worksheets. Here is
my goal for this workbook and I'm hoping someone out there would be
able to explain how I would accomplish it. I am new to this whole
concept. I have no knowledge of VBA or programming with excel. I do
know some C++ but I doubt this will help with this.

GOAL: I would like when the user opens the workbook it would prompt
either with a box that will allow them to check which one they need to
edit or with a drop down box that they can select from. After making
the choice they would select OK and it would then display the correct
worksheet and keep the rest hidden from view. I would then like a
button that they could click to save the file to the same location
everytime no worrying about overwritting the original.

Please let me know if there is anyone that can help.


--
akafrog18
------------------------------------------------------------------------
akafrog18's Profile:
http://www.excelforum.com/member.php...o&userid=32876
View this thread: http://www.excelforum.com/showthread...hreadid=526792

Question from A Newbie
 

Don,

Would you be able to send me an example code for how to create the menu
sheet and the double click event. I have never created macros in Excel.
If you could provide a step by step or something that would be great.

Thanks

Don Guillett Wrote:
Sounds more like a project (which is what many of us do for a living)
instead of a specific question to a specific problem. What you want
can be
done with a workbook_open macro in the ThisWorkbook module using an
input
box to unhide the sheet desired.
Or you could use a menu sheet with the names of the sheets in cells and
a
double click event macro to unhide and goto the sheet desired. Or a
dropdown. Or?

--
Don Guillett
SalesAid Software

"akafrog18"
wrote
in message
...

I currently have a Workbook that has 32 different worksheets. Here
is
my goal for this workbook and I'm hoping someone out there would be
able to explain how I would accomplish it. I am new to this whole
concept. I have no knowledge of VBA or programming with excel. I
do
know some C++ but I doubt this will help with this.

GOAL: I would like when the user opens the workbook it would prompt
either with a box that will allow them to check which one they need
to
edit or with a drop down box that they can select from. After
making
the choice they would select OK and it would then display the
correct
worksheet and keep the rest hidden from view. I would then like a
button that they could click to save the file to the same location
everytime no worrying about overwritting the original.

Please let me know if there is anyone that can help.


--
akafrog18

------------------------------------------------------------------------
akafrog18's Profile:
http://www.excelforum.com/member.php...o&userid=32876
View this thread:
http://www.excelforum.com/showthread...hreadid=526792



--
akafrog18
------------------------------------------------------------------------
akafrog18's Profile: http://www.excelforum.com/member.php...o&userid=32876
View this thread: http://www.excelforum.com/showthread...hreadid=526792

Question from A Newbie
 

Would anyone out there be able to help me do what Don above has said. I
am totally new to VBA and don't know how to do this. Thanks


--
akafrog18
------------------------------------------------------------------------
akafrog18's Profile: http://www.excelforum.com/member.php...o&userid=32876
View this thread: http://www.excelforum.com/showthread...hreadid=526792