Excel 2016 - SDI - Formula Bar

[Jaafar Tribak]

Hi all,

I have just installed office 2016 x64 and I am experimenting for the first time with the new SDI interface with which I am not familiar.

Say, you have two workbooks opened, each on its seperate window (same excel process)

Now, say you want to hide the formula bar just for one workbook, excel 2016 will hide it for both workbooks - Is there a way of just hiding it for one workbook ?

I could use the Workbook Activate event to restore the formula bar when activating the second workbook but I wonder if excel 2016 has a non-vba feature for this.

Thank you.

 

[Jaafar Tribak]

UP!

 

[RoryA]

Not as far as I know. It’s still an application-level setting.

 

[Jaafar Tribak]

Not as far as I know. It’s still an application-level setting.

Thanks very much Rory and sorry for responding late.