Leonard of Quirm
Board Regular
- Joined
- May 19, 2005
- Messages
- 180
Hello all,
I have no experience of using Excel from within Internet Explorer, so any help would be much appreciated!
I have created a workbook containing a macro which has been uploaded to our intranet via a content management system. It is intended to be used by a community of users who activate the link which opens a copy of the workbook within Internet Explorer (rather than in Excel itself).
The workbook functions as follows:
1. Users select a value (let's call it X) from a drop down list in one of the cells and press enter.
2. Pressing enter activates a macro which unhides some hidden sheets and performs lookups using X and then returns the results (based on the lookups) on the original sheet visible to the user, after re-hiding all the lookup sheets.
3. Some supporting text is inserted on the original sheet to explain the results given for X.
Unfortunately, I cannot post my code. But is there some way in which I have to adopt my code to make it work within Internet Explorer (is this possible even)? As it is, nothing happens after performing step 1.
Many thanks,
Matt
I have no experience of using Excel from within Internet Explorer, so any help would be much appreciated!
I have created a workbook containing a macro which has been uploaded to our intranet via a content management system. It is intended to be used by a community of users who activate the link which opens a copy of the workbook within Internet Explorer (rather than in Excel itself).
The workbook functions as follows:
1. Users select a value (let's call it X) from a drop down list in one of the cells and press enter.
2. Pressing enter activates a macro which unhides some hidden sheets and performs lookups using X and then returns the results (based on the lookups) on the original sheet visible to the user, after re-hiding all the lookup sheets.
3. Some supporting text is inserted on the original sheet to explain the results given for X.
Unfortunately, I cannot post my code. But is there some way in which I have to adopt my code to make it work within Internet Explorer (is this possible even)? As it is, nothing happens after performing step 1.
Many thanks,
Matt