Hi,
I am a doctor trying to develop a website (GoDaddy hosted and built by moi with FrontPage) and I have a number of “challenges,” the greatest of which is my basic ignorance regarding some of the more sophisticated procedures for which I am finding need. Any help on any of the following issues will be enormously appreciated.
First, I have developed a rather extensive Excel spreadsheet for deriving clinical diagnoses from signs and symptoms that the doctor/user would record in an interactive worksheet. I would like to embed a working Excel program into the website but I have not been able to figure out a way to do so (many attempted Google suggestions have failed – my fault I’m sure) while protecting the program from being downloaded. Any help on this approach would be really great.
But my “Plan B” if I ultimately cannot embed an interactive Excel worksheet into FrontPage, would be to hyperlink from a website page to the Excel program on my computer. I have tested such a hyperlink and it works simultaneously on multiple computers, so I think this would be an option. I have the worksheet password protected against users deleting, changing formulas, etc. and all cells are locked with the exception of those needed for user input and generated results. However, with this approach, I am faced with 2 issues. The first is the same protection against downloading issue. And the second, upon the user closing the program, I need a way to clear the sheet of all their input. I thought I had a perfect answer to both issues with one approach - to use a macro to disable any “save” capabilities, either with the program save commands or the closing pop-up menu, “Do you want to save the changes you made...” Sounded like a plan, except for my limited macro and VBA coding skills, Through a number of Google forums, I found related “solution” codes, but some didn’t work at all (I’m sure my fault again) and others worked when run, but after closing the program (and successfully clearing the inputted data on reopening), the code did not work on the next closing. I thought I could find code to reactivate the first “do not save” code, but I have failed in every attempt.
Is there anyone with Excel programming skills (and perhaps, Frontpage skills) willing to help this frustrated Pilgrim with some basic (101) step-by-step solutions? I would be most appreciative.
Thank you,
Lou
I am a doctor trying to develop a website (GoDaddy hosted and built by moi with FrontPage) and I have a number of “challenges,” the greatest of which is my basic ignorance regarding some of the more sophisticated procedures for which I am finding need. Any help on any of the following issues will be enormously appreciated.
First, I have developed a rather extensive Excel spreadsheet for deriving clinical diagnoses from signs and symptoms that the doctor/user would record in an interactive worksheet. I would like to embed a working Excel program into the website but I have not been able to figure out a way to do so (many attempted Google suggestions have failed – my fault I’m sure) while protecting the program from being downloaded. Any help on this approach would be really great.
But my “Plan B” if I ultimately cannot embed an interactive Excel worksheet into FrontPage, would be to hyperlink from a website page to the Excel program on my computer. I have tested such a hyperlink and it works simultaneously on multiple computers, so I think this would be an option. I have the worksheet password protected against users deleting, changing formulas, etc. and all cells are locked with the exception of those needed for user input and generated results. However, with this approach, I am faced with 2 issues. The first is the same protection against downloading issue. And the second, upon the user closing the program, I need a way to clear the sheet of all their input. I thought I had a perfect answer to both issues with one approach - to use a macro to disable any “save” capabilities, either with the program save commands or the closing pop-up menu, “Do you want to save the changes you made...” Sounded like a plan, except for my limited macro and VBA coding skills, Through a number of Google forums, I found related “solution” codes, but some didn’t work at all (I’m sure my fault again) and others worked when run, but after closing the program (and successfully clearing the inputted data on reopening), the code did not work on the next closing. I thought I could find code to reactivate the first “do not save” code, but I have failed in every attempt.
Is there anyone with Excel programming skills (and perhaps, Frontpage skills) willing to help this frustrated Pilgrim with some basic (101) step-by-step solutions? I would be most appreciative.
Thank you,
Lou