Hi All,
over the past million years or so, I've developed a series of 5 worksheets that relate to each other via hyperlinks and such.
I've always intended that the user would have to know 'someting' about excel to naviagate around them and enter data.
Recentely, Ive started to consider putting a GUI front end on it and allow the user to use the 5 spreadsheets but through the window of a GUI somehow - hoping then that not as much EXCEL knowledge would be needed by them.
At a high level I would like to this with as little new code as possible - somehow retaining all the functionality of the original sheets, just somehow having the user "deal with them" through the GUI window.
Does anyone have any general ideas about the feasability/practicality of this?
In other words when the users clicks the GUI to say "let me see this chart" - I could use some new macroed code that would copy and past the chart from the old sheet to the GUI window
Any thoughts would be appreciated,
thanks, Joe
over the past million years or so, I've developed a series of 5 worksheets that relate to each other via hyperlinks and such.
I've always intended that the user would have to know 'someting' about excel to naviagate around them and enter data.
Recentely, Ive started to consider putting a GUI front end on it and allow the user to use the 5 spreadsheets but through the window of a GUI somehow - hoping then that not as much EXCEL knowledge would be needed by them.
At a high level I would like to this with as little new code as possible - somehow retaining all the functionality of the original sheets, just somehow having the user "deal with them" through the GUI window.
Does anyone have any general ideas about the feasability/practicality of this?
In other words when the users clicks the GUI to say "let me see this chart" - I could use some new macroed code that would copy and past the chart from the old sheet to the GUI window
Any thoughts would be appreciated,
thanks, Joe