Jump to content
Sign in to follow this  
ash88

Problem with adding model parameters

Recommended Posts

hey guys,


 


I've got a problem adding my model parameters in hyperstudy. I have already enabled the trust vba in the macros security settings in excel however when i try to add model parameters after linking the excel spreadsheet in hyperstudy, an error message attached as a picture in this post turns up. Anyone got any suggestions as to how to solve this issue?


post-4380-0-26118700-1364785956_thumb.jp

Share this post


Link to post
Share on other sites

In some cases, macros security settings may need to be updated. The steps to reach the macro security settings in Excel are version dependent; steps for Excel 2003 and Excel 2007 follow:


Excel 2003


 



 




  • From the Tools pull-down menu, select Marco, and then Security.
  • In the Security dialog box, select the Trusted Publishers tab.
  • Enable the check box next to Trust all installed add-ins and templates.

 


     Excel 2007


 



 




  • Enable the Developer tab in the application ribbon.

(From the Office button in the upper left corner, select Excel Options, pick the Popular formatting panel, and check the box for Show developer tab in ribbon).


  • From the Developer tab, select Macro Security to open the Trust Center dialog box.Enable the check box next to Trust all installed add-ins and templates.
  • In the Trust Center dialog box, select Macro Settings.
  • Enable the option, Trust access to the VBA project object model.

Note that in Europe the separator may be set to “, “. Please verify separator setting: use “.” instead of “,”.


 



Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
You are posting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...