Skip to main content

Posts

Showing posts from January, 2021

Creating a interactive plotly in a spreadsheet

Inserting the Microsoft Web Browser Object This post is for clarification on the  Stack overflow Answer  for Vestland . Step 1: Open a blank spreadsheet and save it as [.xlsm] macro-enabled workbook Step 2: Try inserting Microsoft web-browser Activex Control by following the below steps, Refer to the below pictures for easy understanding                Step 2. 1: Click the Developer Tab                Step 2. 2: Click the Insert                Step 2. 3: Click MoreTools under Activex Control (Last Control)                Step 2. 4: Select Microsoft Web browser                Step 2. 5: Click OK                Step 2. 6: Draw a Rectangle for browser you will get cannot insert Object error like this  Error Snip To fix this error you have to modify some registry settings. 1. Click Win + R to open Run 2. Type Regedit and click Enter to open the registry editor 3. Navigate to  Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\