Hi,
I am new to coding in VBA but I am interested to learn in an assignment that I am doing. i am unable to upload the file since it is large but I have attached a screenshot.
Background:
I am working on an excel workbook that I am supposed to make sure it embeds on the internet explorer browser. It is basically a worksheet that sales people fill in on a daily basis every month that is why we have a constant of days of the week on the horizontal axis and the vehicles and their registration number on the y-axis.
Requirements:
1. Embed the excel workbook to open with Internet Explorer.
2. Any changes made on the excel workbook should be reflected when I save it and open it on IE.
3. Is it possible for the changes that I have made on the excel workbook to be reflected when I open it on IE i.e able to view grid lines, freezes panes and drop down list?
I am new to coding in VBA but I am interested to learn in an assignment that I am doing. i am unable to upload the file since it is large but I have attached a screenshot.
Background:
I am working on an excel workbook that I am supposed to make sure it embeds on the internet explorer browser. It is basically a worksheet that sales people fill in on a daily basis every month that is why we have a constant of days of the week on the horizontal axis and the vehicles and their registration number on the y-axis.
Requirements:
1. Embed the excel workbook to open with Internet Explorer.
2. Any changes made on the excel workbook should be reflected when I save it and open it on IE.
3. Is it possible for the changes that I have made on the excel workbook to be reflected when I open it on IE i.e able to view grid lines, freezes panes and drop down list?